# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年12月24日
"""
import pymysql
import pandas as pd

conn = pymysql.connect(host='localhost', user='root', passwd='123456', db='test', charset='utf8')
sql_query = 'select * from test.user'
data = pd.read_sql(sql_query, con=conn)
conn.close()
# print(data.info())
# print(data.describe())
print(data.isnull().sum())